How to: Add and remove tables on the Table Pane in Microsoft Query.
Solution:
From within MS Query, select 'Add Tables...' from the 'Table' menu. Type the table name and options, then choose 'Add'. Repeat as needed, then choose 'Close'. To remove a table, select it then press DELETE.
NOTE: Only the tables added to the Table Pane are used to supply data for the query, regardless of the number of tables or files in the directory specified as the data source.
1) From within Microsoft Query, select the 'Table' menu and select 'Add Tables...'. (The Add Tables dialog box appears.)
2) Do one of the following:
a) In the 'Table' list box, select the name of the table to add.
b) Select the table from the 'Table List' text box or from the 'Table' list.
NOTE: The options here depend on the ODBC driver in use.
3) Click 'Add' toadd the table to the table pane in the query window.
4) Repeat steps 2) and 3) for each table being added to the pane.
5) Click 'Close'. (This closes the Add Tables dialog box.)
NOTE: To remove a table from the table pane, click anywhere on the table in the pane, and then press DELETE.
